***Replication Files for Evaluating the effects of geographic adjustments on poverty measures using self-reported financial well-being 
*Jeff Larrimore

***Contents:
1. Larrimore_state_poverty_measures.do
2a. NFCS_2018_State_Data_190603.csv
2b. NFCS 2021 State Data 220627.csv
2c. publicSHED2017.dta
2d. publicSHED2018.dta
2e. publicSHED2019.dta
2f. publicSHED2020.dta
2g. publicSHED2021.dta
2h. state_fips_list.dta
2i. ZIP_CBSA_122021.xlsx

***Additional data files required
Two additional data files are required to run the replication file, which cannot be posted publicly due to data restrictions:
3. NFCS_zip.dta. This file contains respondent zipcodes. Data are available from the FINRA Foundation to researchers who sign the data use agreement.
   Olivia Valdez at the FINRA foundation provided the file for this project.
4. CPS0078.dta. This file was downloaded from https://cps.ipums.org/cps/
To download the dataset, select years 2017, 2018, 2019, 2020, 2021, 2022, 2023 with the following variables (this list includes all variables referenced in the program, although not all variables are necessary) 
YEAR; SERIAL; MONTH; CPSID; ASECFLAG; ASECWTH; REGION; STATEFIP; COUNTY; METFIPS; METAREA; METRO; STAMPVAL; HSEQ; PERNUM; CPSIDP; CPSIDV; ASECWT; AGE; RACE; MARST; NCHILD; ELDCH; FTYPE; FAMREL; HISPAN; LINENO; FAMID; INCTOT; INCWAGE; INCBUS; INCFARM; INCSS; INCWELFR; INCRETIR; INCSSI; INCINT; INCUNEMP; INCWKCOM; INCVET; INCSURV; INCDISAB; INCDIVID; INCRENT; INCEDUC; INCCHILD; INCASIST; INCOTHER; INCRANN; INCPENS; OINCBUS; OINCFARM; OINCWAGE; SRCSURV1; SRCSURV2; INCSURV1; INCSURV2; SRCDISA1; SRCDISA2; INCDISA1; INCDISA2; SRCRET1; SRCRET2; INCRET1; INCRET2; FEDTAX; FEDTAXAC; FICA; FILESTAT; DEPSTAT; STATETAX; STATAXAC; TAXINC; OFFPOV; OFFPOVUNIV; OFFTOTVAL; OFFCUTOFF; POVERTY; FOODSTAMP; SCHLLUNCH; SPMLUNCH; SPMCAPHOUS; SPMPOV; SPMMORT; SPMEQSCALE; SPMWT; SPMMEDXPNS; SPMCHXPNS; SPMCAPXPNS; SPMCHSUP; SPMSTTAX; SPMFEDTAXAC; SPMEITC; SPMFICA; SPMFEDTAXBC; SPMWIC; SPMHEAT; SPMSNAP; SPMFTOTVAL; SPMTOTRES; SPMNADULTS; SPMNCHILD; SPMNPERS; SPMGEOADJ; SPMTHRESH; SPMFAMUNIT; SPMWKXPNS; CHSUPPAID; CAIDLY; MOOP; 

***Data source information
NFCS data (files 2a-2b) were obtained from https://finrafoundation.org/knowledge-we-gain-share/nfcs/data-and-downloads
SHED data (files 2c-2g) were obtained from https://www.federalreserve.gov/consumerscommunities/shed_data.htm
ZIP-CBSA crosswalk data (file 2i) was obtained from: https://www.huduser.gov/portal/datasets/usps_crosswalk.html

***Running files
Place all data files in a data directory and revise line 10 of "Larrimore_state_poverty_measures" to that directory
Run Larrimore_state_poverty_measures.do.
